Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_PART_LOBS

`ALL_PART_LOBS` provides table-level information about partitioned LOBs that are accessible to the current user, including default attributes for LOB data partitions.

Related Views

- `DBA_PART_LOBS` provides such information for all partitioned LOBs in the database.

- `USER_PART_LOBS` provides such information for all partitioned LOBs owned by the current user. This view does not display the `OWNER` column.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`TABLE_OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the partitioned table containing LOB(s)
`TABLE_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the partitioned table containing LOB(s)
`COLUMN_NAME` | `VARCHAR2(4000)` |  | Name of the LOB column
`LOB_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the partitioned LOB
`LOB_INDEX_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the partitioned LOB index
`DEF_CHUNK` | `NUMBER` | `NOT NULL` | Default value of `CHUNK` for a LOB data partition to be used when adding a partition
`DEF_PCTVERSION` | `NUMBER` | `NOT NULL` | Default value of `PCTVERSION` for a LOB data partition to be used when adding a partition
`DEF_CACHE` | `VARCHAR2(10)` |  | Whether and how the cluster is to be cached by default in the buffer cache (`CACHE`, `NOCACHE`, `CACHEREADS`)
`DEF_IN_ROW` | `VARCHAR2(3)` |  | Whether LOB data < 4000 bytes is stored in the row (inline)—that is, whether `ENABLE STORAGE IN ROW` was specified when the LOB column was created or last altered
`DEF_TABLESPACE_NAME` | `VARCHAR2(30)` |  | Default tablespace for a LOB data partition to be used when adding a partition
`DEF_INITIAL_EXTENT` | `VARCHAR2(40)` |  | Default value of `INITIAL` for a LOB data partition to be used when adding a partition
`DEF_NEXT_EXTENT` | `VARCHAR2(40)` |  | Default value of `NEXT` for a LOB data partition to be used when adding a partition
`DEF_MIN_EXTENTS` | `VARCHAR2(40)` |  | Default value of `MINEXTENT` for a LOB data partition to be used when adding a partition
`DEF_MAX_EXTENTS` | `VARCHAR2(40)` |  | Default value of `MAXEXTENTS` for a LOB data partition to be used when adding a partition
`DEF_PCT_INCREASE` | `VARCHAR2(40)` |  | Default value of `PCTINCREASE` for a LOB data partition to be used when adding a partition
`DEF_FREELISTS` | `VARCHAR2(40)` |  | Default value of `FREELISTS` for a LOB data partition to be used when adding a partition
`DEF_FREELIST_GROUPS` | `VARCHAR2(40)` |  | Default value of `FREELIST GROUPS` for a LOB data partition to be used when adding a partition
`DEF_LOGGING` | `VARCHAR2(7)` |  | Default `LOGGING` attribute for a LOB data partition to be used when adding a partition
`DEF_BUFFER_POOL` | `VARCHAR2(7)` |  | Default buffer pool for a LOB data partition to be used when adding a partition